explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aw49

Settings
# exclusive inclusive rows x rows loops node
1. 0.349 19,699.958 ↑ 1.0 1 1

Aggregate (cost=175,366.61..175,366.62 rows=1 width=8) (actual time=19,699.958..19,699.958 rows=1 loops=1)

2. 0.158 19,699.609 ↑ 1.0 1,000 1

Limit (cost=1,001.02..175,354.11 rows=1,000 width=24) (actual time=16,776.892..19,699.609 rows=1,000 loops=1)

3. 0.000 19,699.451 ↑ 88.5 1,000 1

Gather Merge (cost=1,001.02..15,423,054.79 rows=88,453 width=24) (actual time=16,776.891..19,699.451 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 96.117 58,251.135 ↑ 100.4 367 3

Nested Loop Semi Join (cost=1.00..15,411,845.10 rows=36,855 width=24) (actual time=11,750.625..19,417.045 rows=367 loops=3)

5. 29,442.882 29,442.882 ↑ 63.1 58,358 3

Parallel Index Scan using billing_admin_billingdefinition_updated_at_61c60ceb on billing_admin_billingdefinition (cost=0.43..4,597,310.78 rows=3,681,645 width=24) (actual time=0.018..9,814.294 rows=58,358 loops=3)

6. 28,712.136 28,712.136 ↓ 0.0 0 175,074

Index Scan using billing_admin_cycletime_billing_definition_id_d64292f6 on billing_admin_cycletime cycle_time (cost=0.56..2.94 rows=1 width=16) (actual time=0.164..0.164 rows=0 loops=175,074)

  • Index Cond: (billing_definition_id = billing_admin_billingdefinition.id)
  • Filter: ((frequency)::text = 'daily'::text)
  • Rows Removed by Filter: 1
Planning time : 1.368 ms
Execution time : 19,700.103 ms