explain.depesz.com

PostgreSQL's explain analyze made readable

Result: quF

Settings
# exclusive inclusive rows x rows loops node
1. 520.025 2,703.333 ↓ 2.8 594,198 1

Merge Left Join (cost=26,757.03..115,516.00 rows=210,600 width=6,355) (actual time=256.260..2,703.333 rows=594,198 loops=1)

  • Merge Cond: (celex0_.id = celexgrade4_.celex_id)
2. 259.161 1,796.297 ↓ 1.5 318,060 1

Merge Left Join (cost=1.67..85,737.73 rows=210,600 width=6,302) (actual time=0.045..1,796.297 rows=318,060 loops=1)

  • Merge Cond: (celex0_.id = dircode3_.celex_id)
3. 287.936 1,382.745 ↑ 1.0 210,600 1

Nested Loop Left Join (cost=1.25..78,781.13 rows=210,600 width=6,288) (actual time=0.035..1,382.745 rows=210,600 loops=1)

4. 374.077 884.209 ↑ 1.0 210,600 1

Merge Join (cost=1.11..42,977.22 rows=210,600 width=6,188) (actual time=0.030..884.209 rows=210,600 loops=1)

  • Merge Cond: (celex0_.id = jurisdicio2_.celex_id)
5. 356.343 356.343 ↑ 1.0 483,606 1

Index Scan using ppcg_celex_pkey on ppcg_celex celex0_ (cost=0.42..31,200.21 rows=483,606 width=2,420) (actual time=0.014..356.343 rows=483,606 loops=1)

6. 153.789 153.789 ↑ 1.0 210,600 1

Index Scan using "celexFKindex" on ppcg_celex_jurisdiction jurisdicio2_ (cost=0.42..7,935.73 rows=210,600 width=3,768) (actual time=0.011..153.789 rows=210,600 loops=1)

  • Filter: (NOT deleted)
7. 210.600 210.600 ↑ 1.0 1 210,600

Index Scan using ppcg_legal_act_type_pkey on ppcg_legal_act_type legalactty1_ (cost=0.14..0.16 rows=1 width=100) (actual time=0.001..0.001 rows=1 loops=210,600)

  • Index Cond: (celex0_.celextype_id = id)
8. 154.391 154.391 ↓ 1.5 318,060 1

Index Scan using "celexFKDircodeindex" on ppcg_celex_dircode dircode3_ (cost=0.42..4,986.63 rows=210,600 width=14) (actual time=0.008..154.391 rows=318,060 loops=1)

9. 64.802 387.011 ↓ 2.8 594,198 1

Materialize (cost=26,755.26..27,808.26 rows=210,600 width=53) (actual time=256.208..387.011 rows=594,198 loops=1)

10. 289.110 322.209 ↑ 1.0 210,600 1

Sort (cost=26,755.26..27,281.76 rows=210,600 width=53) (actual time=256.200..322.209 rows=210,600 loops=1)

  • Sort Key: celexgrade4_.celex_id
  • Sort Method: external sort Disk: 10704kB
11. 33.099 33.099 ↑ 1.0 210,600 1

Seq Scan on ppcg_celex_grade celexgrade4_ (cost=0.00..3,917.00 rows=210,600 width=53) (actual time=0.012..33.099 rows=210,600 loops=1)