explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZ5a

Settings
# exclusive inclusive rows x rows loops node
1. 3.170 985.389 ↑ 1.0 1 1

GroupAggregate (cost=20,000,017,289.37..40,000,068,847.85 rows=1 width=88) (actual time=984.994..985.389 rows=1 loops=1)

  • Group Key: NULL::integer
2. 3.402 982.219 ↑ 2.2 8,281 1

Hash Left Join (cost=20,000,017,289.37..40,000,068,615.22 rows=18,610 width=44) (actual time=44.388..982.219 rows=8,281 loops=1)

  • Hash Cond: ("*SELECT* 1".se_id = (jet.key)::integer)
3. 4.483 978.817 ↑ 2.2 8,281 1

Hash Join (cost=20,000,017,287.12..40,000,068,403.60 rows=18,610 width=12) (actual time=44.304..978.817 rows=8,281 loops=1)

  • Hash Cond: (c.br_id = b.id)
4. 19.056 974.334 ↑ 2.2 8,281 1

Hash Join (cost=20,000,017,285.74..40,000,068,341.19 rows=18,610 width=16) (actual time=44.253..974.334 rows=8,281 loops=1)

  • Hash Cond: ("*SELECT* 1".zo_id = z.id)
5. 14.649 955.278 ↑ 2.2 8,281 1

Hash Join (cost=20,000,016,656.96..40,000,067,663.54 rows=18,610 width=20) (actual time=30.007..955.278 rows=8,281 loops=1)

  • Hash Cond: ("*SELECT* 1".co_id = c.lo_id)
6. 869.535 940.629 ↑ 2.2 8,281 1

Append (cost=20,000,016,286.45..40,000,067,244.17 rows=18,610 width=20) (actual time=21.288..940.629 rows=8,281 loops=1)

7. 1.352 71.094 ↑ 1.8 4,703 1

Subquery Scan on *SELECT* 1 (cost=20,000,016,286.45..20,000,017,680.36 rows=8,652 width=20) (actual time=21.286..71.094 rows=4,703 loops=1)

8. 1.670 69.742 ↑ 1.8 4,703 1

Nested Loop (cost=20,000,016,286.45..20,000,017,593.84 rows=8,652 width=60) (actual time=21.284..69.742 rows=4,703 loops=1)

9. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on rtbr_102095 b_1 (cost=0.00..1.21 rows=1 width=4) (actual time=0.013..0.015 rows=1 loops=1)

  • Filter: (id = 926)
  • Rows Removed by Filter: 16
10. 16.014 68.057 ↑ 1.8 4,703 1

Hash Join (cost=10,000,016,286.45..10,000,017,506.10 rows=8,652 width=24) (actual time=21.265..68.057 rows=4,703 loops=1)

  • Hash Cond: (av_.zo_id = z_1.id)
11. 1.613 52.043 ↑ 1.8 4,703 1

Nested Loop (cost=10,000,015,657.67..10,000,016,854.61 rows=8,652 width=24) (actual time=8.185..52.043 rows=4,703 loops=1)

12. 0.032 0.032 ↑ 1.0 1 1

Index Scan using idx_sepead_140422 on rt_sepeadsh_140422 av_1 (cost=0.28..8.30 rows=1 width=10) (actual time=0.028..0.032 rows=1 loops=1)

  • Index Cond: ((se_id = 12) AND (pe_id = 70) AND (ad_id = 335))
  • Filter: (id = 2,342)
13. 8.068 50.398 ↑ 1.8 4,703 1

Hash Join (cost=15,657.39..16,759.79 rows=8,652 width=30) (actual time=8.151..50.398 rows=4,703 loops=1)

  • Hash Cond: (av_.co_id = act.co_id)
14. 15.953 42.330 ↑ 3.0 4,775 1

Hash Join (cost=244.93..1,310.01 rows=14,207 width=26) (actual time=3.338..42.330 rows=4,775 loops=1)

  • Hash Cond: (av_.co_id = c_1.lo_id)
15. 23.155 23.155 ↑ 1.0 49,523 1

Seq Scan on rtsepezocoav_12_70_335_292247 av_ (cost=0.00..935.04 rows=49,523 width=18) (actual time=0.037..23.155 rows=49,523 loops=1)

  • Filter: (combi_id = 2,342)
16. 1.347 3.222 ↑ 1.0 3,806 1

Hash (cost=197.36..197.36 rows=3,806 width=8) (actual time=3.221..3.222 rows=3,806 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 181kB
17. 1.875 1.875 ↑ 1.0 3,806 1

Bitmap Heap Scan on rtco_120185 c_1 (cost=77.78..197.36 rows=3,806 width=8) (actual time=0.549..1.875 rows=3,806 loops=1)

  • Recheck Cond: (br_id = 926)
  • Heap Blocks: exact=26