explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wshh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,845.518 ↑ 1.0 30 1

Limit (cost=2,600,888.59..2,600,892.18 rows=30 width=160) (actual time=1,845.450..1,845.518 rows=30 loops=1)

2. 58.859 1,892.277 ↑ 599,030.9 30 1

Gather Merge (cost=2,600,888.59..4,752,631.19 rows=17,970,928 width=160) (actual time=1,845.448..1,892.277 rows=30 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 5.537 1,833.418 ↑ 23,646.0 190 5 / 5

Sort (cost=2,599,888.53..2,611,120.36 rows=4,492,732 width=160) (actual time=1,833.399..1,833.418 rows=190 loops=5)

  • Sort Key: november_india."november_romeo" oscar foxtrot, india3."uniform
  • Sort Method: quicksort Memory: 1,318kB
4. 2.155 1,827.881 ↑ 1,207.1 3,722 5 / 5

Hash Left Join (cost=45.02..1,699,816.48 rows=4,492,732 width=160) (actual time=1,559.253..1,827.881 rows=3,722 loops=5)

  • Hash Cond: (india3.quebec_seven = november_india."quebec_foxtrot")
5. 1,825.694 1,825.694 ↑ 1,207.1 3,722 5 / 5

Parallel Seq Scan on six (cost=0.00..1,447,051.31 rows=4,492,732 width=152) (actual time=1,559.139..1,825.694 rows=3,722 loops=5)

6. 0.001 0.032 ↓ 0.0 0 4 / 5

Hash (cost=44.48..44.48 rows=43 width=16) (actual time=0.040..0.040 rows=0 loops=4)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
7. 0.031 0.031 ↓ 0.0 0 4 / 5

Index Scan using romeo on november_india (cost=0.42..44.48 rows=43 width=16) (actual time=0.039..0.039 rows=0 loops=4)

  • Index Cond: ("kilo" = 2)
Planning time : 0.934 ms
Execution time : 1,892.462 ms