explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lK31

Settings
# exclusive inclusive rows x rows loops node
1. 135.374 8,469.615 ↑ 1.9 13,141 1

GroupAggregate (cost=418,793.62..420,453.29 rows=25,000 width=68) (actual time=8,311.393..8,469.615 rows=13,141 loops=1)

  • Group Key: lec.entity_id
2. 110.462 8,334.241 ↑ 1.0 113,012 1

Sort (cost=418,793.62..419,083.54 rows=115,967 width=28) (actual time=8,311.263..8,334.241 rows=113,012 loops=1)

  • Sort Key: lec.entity_id
  • Sort Method: external merge Disk: 2,488kB
3. 0.000 8,223.779 ↑ 1.0 113,012 1

Gather (cost=2,512.41..407,413.20 rows=115,967 width=28) (actual time=15.878..8,223.779 rows=113,012 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 4,047.298 8,244.082 ↑ 1.3 22,602 5 / 5

Nested Loop Left Join (cost=1,512.41..394,816.50 rows=28,992 width=28) (actual time=7.136..8,244.082 rows=22,602 loops=5)

  • Join Filter: ((NOT lec.global) AND (dc.id = lec.country_id))
  • Rows Removed by Join Filter: 7,571,804
5. 33.904 83.147 ↑ 1.3 22,602 5 / 5

Hash Left Join (cost=1,512.41..60,321.30 rows=28,992 width=25) (actual time=7.019..83.147 rows=22,602 loops=5)

  • Hash Cond: (lec.country_id = dc.id)
  • Join Filter: lec.global
  • Rows Removed by Join Filter: 2,043
6. 47.782 49.042 ↑ 1.3 22,602 5 / 5

Parallel Bitmap Heap Scan on link_entity_country lec (cost=1,500.88..60,232.74 rows=28,992 width=9) (actual time=6.707..49.042 rows=22,602 loops=5)

  • Recheck Cond: (entity_type_id = 18)
  • Heap Blocks: exact=1,822
7. 1.260 1.260 ↑ 1.0 113,012 1 / 5

Bitmap Index Scan on idx_link_entity_country_5 (cost=0.00..1,471.88 rows=115,967 width=0) (actual time=6.302..6.302 rows=113,012 loops=1)

  • Index Cond: (entity_type_id = 18)
8. 0.097 0.201 ↑ 1.0 335 5 / 5

Hash (cost=7.35..7.35 rows=335 width=16) (actual time=0.201..0.201 rows=335 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
9. 0.104 0.104 ↑ 1.0 335 5 / 5

Seq Scan on delivery_country dc (cost=0.00..7.35 rows=335 width=16) (actual time=0.013..0.104 rows=335 loops=5)

10. 4,113.637 4,113.637 ↑ 1.0 335 113,012 / 5

Seq Scan on delivery_country dc2 (cost=0.00..7.35 rows=335 width=12) (actual time=0.001..0.182 rows=335 loops=113,012)

Planning time : 0.237 ms
Execution time : 8,472.417 ms