explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uw5r

Settings
# exclusive inclusive rows x rows loops node
1. 0.354 74,153.249 ↑ 1.0 1 1

Aggregate (cost=77,601.75..77,601.76 rows=1 width=8) (actual time=74,153.249..74,153.249 rows=1 loops=1)

2. 0.166 74,152.895 ↑ 1.0 1,000 1

Limit (cost=1,000.89..77,589.25 rows=1,000 width=16) (actual time=72,811.032..74,152.895 rows=1,000 loops=1)

3. 0.000 74,152.729 ↑ 153.0 1,000 1

Gather Merge (cost=1,000.89..11,722,618.57 rows=153,047 width=16) (actual time=72,811.031..74,152.729 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 156.561 221,590.794 ↑ 189.8 336 3

Nested Loop Semi Join (cost=0.87..11,703,953.12 rows=63,770 width=16) (actual time=72,797.527..73,863.598 rows=336 loops=3)

5. 161,470.407 161,470.407 ↑ 4.8 768,767 3

Parallel Index Scan using billing_admin_billingdefinitionseq_updated_at_f7f9727c on billing_admin_billingdefinitionseq (cost=0.43..5,946,170.89 rows=3,661,128 width=16) (actual time=2.088..53,823.469 rows=768,767 loops=3)

6. 59,963.826 59,963.826 ↓ 0.0 0 2,306,301

Index Scan using billing_admin_cycletimeseq_billing_definition_id_e8016196 on billing_admin_cycletimeseq cycle_time (cost=0.43..1.57 rows=1 width=8) (actual time=0.026..0.026 rows=0 loops=2,306,301)

  • Index Cond: (billing_definition_id = billing_admin_billingdefinitionseq.id)
  • Filter: ((frequency)::text = 'daily'::text)
  • Rows Removed by Filter: 1
Planning time : 31.323 ms
Execution time : 74,153.350 ms