explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AQ1G

Settings
# exclusive inclusive rows x rows loops node
1. 4.283 1,569.524 ↓ 141.0 141 1

Gather (cost=1,008.44..811,835.28 rows=1 width=58) (actual time=428.941..1,569.524 rows=141 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.181 1,565.241 ↓ 47.0 47 3

Hash Join (cost=8.44..810,835.18 rows=1 width=58) (actual time=217.249..1,565.241 rows=47 loops=3)

  • Hash Cond: (stats.testcase = testcases.id)
3. 1,565.038 1,565.038 ↓ 1.0 846 3

Parallel Seq Scan on stats (cost=0.00..810,824.60 rows=816 width=58) (actual time=53.647..1,565.038 rows=846 loops=3)

  • Filter: ((date < '1509138583001'::bigint) AND ((suite)::text = 'tct-libstorage-native-itc'::text))
  • Rows Removed by Filter: 15465906
4. 0.002 0.022 ↑ 1.0 1 3

Hash (cost=8.43..8.43 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.020 0.020 ↑ 1.0 1 3

Index Scan using testcases_name_key on testcases (cost=0.41..8.43 rows=1 width=8) (actual time=0.019..0.020 rows=1 loops=3)

  • Index Cond: ((name)::text = 'ITc_libstorage_get_internal_memory_size_p'::text)