explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dLFM

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 14.557 ↓ 0.0 0 1

Delete on transitionchrominfoannotation (cost=35,104,436.75..35,380,129.42 rows=241,358 width=42) (actual time=14.557..14.557 rows=0 loops=1)

2. 0.388 14.553 ↓ 0.0 0 1

Hash Semi Join (cost=35,104,436.75..35,380,129.42 rows=241,358 width=42) (actual time=14.553..14.553 rows=0 loops=1)

  • Hash Cond: (transitionchrominfoannotation.transitionchrominfoid = tci.id)
3. 0.009 0.009 ↑ 8,834,896.0 1 1

Seq Scan on transitionchrominfoannotation (cost=0.00..162,740.96 rows=8,834,896 width=14) (actual time=0.009..0.009 rows=1 loops=1)

4. 0.000 14.156 ↓ 0.0 0 1

Hash (cost=35,102,512.10..35,102,512.10 rows=90,372 width=44) (actual time=14.156..14.156 rows=0 loops=1)

  • Buckets: 65,536 Batches: 4 Memory Usage: 512kB
5. 0.073 14.156 ↓ 0.0 0 1

Hash Join (cost=465,599.96..35,102,512.10 rows=90,372 width=44) (actual time=14.156..14.156 rows=0 loops=1)

  • Hash Cond: (tci.transitionid = gt.id)
6. 0.078 0.078 ↑ 1,234,577,408.0 1 1

Seq Scan on transitionchrominfo tci (cost=0.00..30,006,343.08 rows=1,234,577,408 width=18) (actual time=0.078..0.078 rows=1 loops=1)

7. 0.018 14.005 ↓ 0.0 0 1

Hash (cost=465,526.11..465,526.11 rows=5,908 width=34) (actual time=14.005..14.005 rows=0 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 64kB
8. 0.000 13.987 ↓ 0.0 0 1

Nested Loop (cost=1.87..465,526.11 rows=5,908 width=34) (actual time=13.987..13.987 rows=0 loops=1)

9. 0.001 13.987 ↓ 0.0 0 1

Nested Loop (cost=1.30..19,077.44 rows=904 width=28) (actual time=13.987..13.987 rows=0 loops=1)

10. 0.000 13.986 ↓ 0.0 0 1

Nested Loop (cost=0.86..12,007.72 rows=827 width=22) (actual time=13.986..13.986 rows=0 loops=1)

11. 0.000 13.986 ↓ 0.0 0 1

Nested Loop (cost=0.43..3,070.16 rows=133 width=16) (actual time=13.986..13.986 rows=0 loops=1)

  • -> Index Scan using ix_peptidegroup_runid on peptidegroup pg (cost=0.43..636.26 rows=671 width=14) (neverexecuted)
12. 13.986 13.986 ↓ 0.0 0 1

Seq Scan on runs r (cost=0.00..1,784.22 rows=2 width=10) (actual time=13.986..13.986 rows=0 loops=1)

  • Filter: deleted
  • Rows Removed by Filter: 27,320
  • Index Cond: (runid = r.id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_peptide_peptidegroupid on generalmolecule gm (cost=0.43..66.60 rows=60 width=14) (never executed)

  • Index Cond: (peptidegroupid = pg.id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_precursor_gmid on generalprecursor gp (cost=0.43..8.53 rows=2 width=14) (never executed)

  • Index Cond: (generalmoleculeid = gm.id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_transition_precursorid on generaltransition gt (cost=0.57..491.71 rows=215 width=14) (never executed)

  • Index Cond: (generalprecursorid = gp.id)