explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gZBP

Settings
# exclusive inclusive rows x rows loops node
1. 55.288 56,231.846 ↓ 14.1 141 1

Gather (cost=1,013.42..1,378,611.00 rows=10 width=16) (actual time=33,889.930..56,231.846 rows=141 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.145 56,176.558 ↓ 11.8 47 3

Hash Join (cost=13.42..1,377,610.00 rows=4 width=16) (actual time=36,080.172..56,176.558 rows=47 loops=3)

  • Hash Cond: (stats.suiteid = suites.id)
3. 1,489.330 56,176.349 ↑ 20.6 47 3

Hash Join (cost=8.44..1,377,602.43 rows=970 width=20) (actual time=36,079.992..56,176.349 rows=47 loops=3)

  • Hash Cond: (stats.testcase = testcases.id)
4. 54,686.993 54,686.993 ↑ 1.2 15,466,752 3

Parallel Seq Scan on stats (cost=0.00..1,326,980.62 rows=19,277,170 width=28) (actual time=339.948..54,686.993 rows=15,466,752 loops=3)

  • Filter: (date < '1509138583001'::bigint)
5. 0.004 0.026 ↑ 1.0 1 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.022 0.022 ↑ 1.0 1 3

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

  • Index Cond: ((name)::text = 'ITc_libstorage_get_internal_memory_size_p'::text)
7. 0.003 0.064 ↑ 1.0 1 3

Hash (cost=4.96..4.96 rows=1 width=8) (actual time=0.064..0.064 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.061 0.061 ↑ 1.0 1 3

Seq Scan on suites (cost=0.00..4.96 rows=1 width=8) (actual time=0.042..0.061 rows=1 loops=3)

  • Filter: ((name)::text = 'tct-libstorage-native-itc'::text)
  • Rows Removed by Filter: 236