explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XlIU

Settings
# exclusive inclusive rows x rows loops node
1. 37.506 56,280.180 ↓ 141.0 141 1

Gather (cost=1,008.44..1,376,184.15 rows=1 width=16) (actual time=32,992.226..56,280.180 rows=141 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.355 56,242.674 ↓ 47.0 47 3

Hash Join (cost=8.44..1,375,184.05 rows=1 width=16) (actual time=34,966.582..56,242.674 rows=47 loops=3)

  • Hash Cond: (stats.testcase = testcases.id)
3. 56,242.278 56,242.278 ↓ 1.1 846 3

Parallel Seq Scan on stats (cost=0.00..1,375,173.55 rows=784 width=24) (actual time=33,822.164..56,242.278 rows=846 loops=3)

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

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

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

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

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