explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jewh

Settings
# exclusive inclusive rows x rows loops node
1. 88.857 92,876.921 ↑ 103.4 10,127 1

Gather (cost=2,604.00..2,511,304.86 rows=1,047,565 width=751) (actual time=781.020..92,876.921 rows=10,127 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • JIT:
  • Functions: 57
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 17.194 ms, Inlining 195.040 ms, Optimization 1144.488 ms, Emission 558.703 ms, Total 1915.426 ms
2. 92,739.361 92,788.064 ↑ 129.3 3,376 3 / 3

Parallel Seq Scan on royalties_transaction (cost=1,604.00..2,405,548.36 rows=436,485 width=751) (actual time=752.707..92,788.064 rows=3,376 loops=3)

  • Filter: ((customer_id = 22) AND (((contract_id IS NULL) AND (hashed SubPlan 1)) OR (contract_id = 13,142)))
  • Rows Removed by Filter: 7,977,184
3.          

SubPlan (for Parallel Seq Scan)

4. 0.034 48.703 ↓ 1.6 23 3 / 3

Nested Loop (cost=0.29..1,603.96 rows=14 width=4) (actual time=41.389..48.703 rows=23 loops=3)

5. 42.574 42.574 ↓ 1.5 23 3 / 3

Seq Scan on royalties_calculated_item_contract u1 (cost=0.00..1,519.31 rows=15 width=4) (actual time=36.484..42.574 rows=23 loops=3)

  • Filter: (contract_id = 13,142)
  • Rows Removed by Filter: 76,808
6. 6.095 6.095 ↑ 1.0 1 69 / 3

Index Only Scan using royalties_release_pkey on royalties_item u0 (cost=0.29..5.64 rows=1 width=4) (actual time=0.265..0.265 rows=1 loops=69)

  • Index Cond: (id = u1.item_id)
  • Heap Fetches: 42
Planning time : 0.316 ms
Execution time : 92,882.126 ms