explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UkOD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,847.007 ↓ 0.0 0 1

Unique (cost=445,831.20..445,831.29 rows=19 width=328) (actual time=10,847.007..10,847.007 rows=0 loops=1)

2. 0.000 10,847.007 ↓ 0.0 0 1

Sort (cost=445,831.20..445,831.25 rows=19 width=328) (actual time=10,847.006..10,847.007 rows=0 loops=1)

  • Sort Key: cmh.id, cmh.sys_period DESC
  • Sort Method: quicksort Memory: 25kB
3. 1,727.798 11,714.571 ↓ 0.0 0 1

Gather (cost=362,870.78..445,830.79 rows=19 width=328) (actual time=10,846.959..11,714.571 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 0.001 9,986.773 ↓ 0.0 0 5 / 5

Nested Loop Semi Join (cost=361,870.78..444,828.89 rows=5 width=328) (actual time=9,986.773..9,986.773 rows=0 loops=5)

5. 0.002 9,986.772 ↓ 0.0 0 5 / 5

Nested Loop (cost=361,870.49..444,827.32 rows=5 width=328) (actual time=9,986.772..9,986.772 rows=0 loops=5)

6. 0.002 9,986.770 ↓ 0.0 0 5 / 5

Nested Loop Anti Join (cost=361,870.20..444,825.74 rows=5 width=324) (actual time=9,986.770..9,986.770 rows=0 loops=5)

7. 0.114 9,986.768 ↓ 0.0 0 5 / 5

Hash Join (cost=361,869.77..444,822.60 rows=7 width=324) (actual time=9,986.768..9,986.768 rows=0 loops=5)

  • Hash Cond: (cmh.channel_thesaurus_line_id = tlh.id)
8. 0.022 0.022 ↑ 1,313,291.0 1 5 / 5

Parallel Seq Scan on category_mapping_history cmh (cost=0.00..78,027.91 rows=1,313,291 width=328) (actual time=0.022..0.022 rows=1 loops=5)

9. 0.008 9,986.632 ↓ 0.0 0 5 / 5

Hash (cost=361,869.76..361,869.76 rows=1 width=4) (actual time=9,986.632..9,986.632 rows=0 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
10. 9,986.624 9,986.624 ↓ 0.0 0 5 / 5

Index Scan using thesaurus_line_history_pkey on thesaurus_line_history tlh (cost=0.56..361,869.76 rows=1 width=4) (actual time=9,986.624..9,986.624 rows=0 loops=5)

  • Filter: ((channel_code = '''0S091T'''::text) AND (channel_thesaurus_id = 4,662))
  • Rows Removed by Filter: 12,072,945
11. 0.000 0.000 ↓ 0.0 0 / 5

Index Only Scan using category_mapping_pkey on category_mapping cm (cost=0.43..0.45 rows=1 width=4) (never executed)

  • Index Cond: (id = cmh.id)
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0 / 5

Index Only Scan using structure_mapping_pkey on structure_mapping sm (cost=0.29..0.31 rows=1 width=4) (never executed)

  • Index Cond: (id = cmh.catalog_feed_id)
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0 / 5

Index Only Scan using structure_mapping_pkey on structure_mapping sm_1 (cost=0.29..0.31 rows=1 width=4) (never executed)

  • Index Cond: (id = cmh.catalog_feed_id)
  • Heap Fetches: 0
Planning time : 1.889 ms
Execution time : 11,714.867 ms