explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BEOw

Settings
# exclusive inclusive rows x rows loops node
1. 7.543 1,368.125 ↓ 0.0 0 1

Gather (cost=1,000.43..214,162.55 rows=3 width=4) (actual time=1,366.547..1,368.125 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 1,223.414 1,360.582 ↓ 0.0 0 5

Nested Loop (cost=0.43..213,162.25 rows=1 width=4) (actual time=1,360.582..1,360.582 rows=0 loops=5)

3. 137.160 137.160 ↑ 1.2 140,318 5

Parallel Seq Scan on slr_bnev_register (cost=0.00..45,292.65 rows=173,032 width=8) (actual time=1.421..137.160 rows=140,318 loops=5)

  • Filter: (period_date = '2019-03-01'::date)
  • Rows Removed by Filter: 659533
4. 0.008 0.008 ↓ 0.0 0 701,591

Index Scan using slr_nbev_pkey on slr_nbev (cost=0.43..0.96 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=701,591)

  • Index Cond: (id = slr_bnev_register.bnev_id)
  • Filter: ((slr_bnev_register.bnev_id = 1234) OR (replaced_by_id = 1234))
  • Rows Removed by Filter: 1
Planning time : 0.367 ms
Execution time : 1,368.183 ms