explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HTvG

Settings
# exclusive inclusive rows x rows loops node
1. 491.063 2,451.914 ↓ 2.8 580,557 1

Hash Left Join (cost=6.61..59,402.67 rows=207,645 width=6,355) (actual time=0.101..2,451.914 rows=580,557 loops=1)

  • Hash Cond: (celex0_.celextype_id = legalactty1_.id)
  • Buffers: shared hit=791901
2. 512.380 1,960.810 ↓ 2.8 580,557 1

Merge Left Join (cost=2.85..56,873.89 rows=207,645 width=6,255) (actual time=0.052..1,960.810 rows=580,557 loops=1)

  • Merge Cond: (celex0_.id = celexgrade4_.celex_id)
  • Buffers: shared hit=791899
3. 259.653 1,194.381 ↓ 1.5 312,381 1

Merge Left Join (cost=2.43..49,372.81 rows=207,645 width=6,202) (actual time=0.041..1,194.381 rows=312,381 loops=1)

  • Merge Cond: (celex0_.id = dircode3_.celex_id)
  • Buffers: shared hit=517440
4. 342.698 796.171 ↑ 1.0 207,558 1

Merge Join (cost=2.01..42,494.71 rows=207,645 width=6,188) (actual time=0.030..796.171 rows=207,558 loops=1)

  • Merge Cond: (celex0_.id = jurisdicio2_.celex_id)
  • Buffers: shared hit=370174
5. 264.560 264.560 ↑ 1.0 483,606 1

Index Scan using ppcg_celex_pkey on ppcg_celex celex0_ (cost=0.42..30,286.51 rows=483,606 width=2,420) (actual time=0.011..264.560 rows=483,606 loops=1)

  • Buffers: shared hit=267628
6. 188.913 188.913 ↑ 1.0 207,558 1

Index Scan using "celexIDFKProba" on ppcg_celex_jurisdiction jurisdicio2_ (cost=0.42..8,403.92 rows=207,645 width=3,768) (actual time=0.015..188.913 rows=207,558 loops=1)

  • Filter: ((NOT deleted) AND ((institucion)::text <> ''::text))
  • Rows Removed by Filter: 3042
  • Buffers: shared hit=102546
7. 138.557 138.557 ↓ 1.5 313,772 1

Index Scan using "celexFKDircodeindex" on ppcg_celex_dircode dircode3_ (cost=0.42..4,928.42 rows=210,600 width=14) (actual time=0.010..138.557 rows=313,772 loops=1)

  • Buffers: shared hit=147266
8. 254.049 254.049 ↓ 2.8 581,948 1

Index Scan using "indeProba" on ppcg_celex_grade celexgrade4_ (cost=0.42..5,551.42 rows=210,600 width=53) (actual time=0.009..254.049 rows=581,948 loops=1)

  • Buffers: shared hit=274459
9. 0.025 0.041 ↑ 1.0 78 1

Hash (cost=2.78..2.78 rows=78 width=100) (actual time=0.041..0.041 rows=78 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
  • Buffers: shared hit=2
10. 0.016 0.016 ↑ 1.0 78 1

Seq Scan on ppcg_legal_act_type legalactty1_ (cost=0.00..2.78 rows=78 width=100) (actual time=0.003..0.016 rows=78 loops=1)

  • Buffers: shared hit=2