explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eNAm : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #PTt4; plan #1SCb; plan #3jBG; plan #MlVt; plan #yWZ2; plan #YNP3

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 36,585.400 36,952.718 ↓ 0.0 0 1

Delete on transfer_perturbations tp (cost=66,774.55..137,114.93 rows=1,751,405 width=42) (actual time=36,952.718..36,952.718 rows=0 loops=1)

2. 96.000 367.318 ↑ 10.2 172,260 1

Nested Loop (cost=66,774.55..137,114.93 rows=1,751,405 width=42) (actual time=35.274..367.318 rows=172,260 loops=1)

3. 0.467 44.194 ↑ 1.9 324 1

Nested Loop (cost=66,773.98..80,582.50 rows=615 width=44) (actual time=35.260..44.194 rows=324 loops=1)

4. 4.451 35.627 ↑ 9.2 324 1

HashAggregate (cost=66,773.43..66,803.12 rows=2,969 width=34) (actual time=35.251..35.627 rows=324 loops=1)

  • Group Key: ip.id
5. 5.958 31.176 ↓ 4.4 12,960 1

Nested Loop Left Join (cost=1.96..66,766.00 rows=2,969 width=34) (actual time=0.425..31.176 rows=12,960 loops=1)

  • Filter: ((ippc.id IS NULL) OR (ippc.mutable IS TRUE))
6. 0.225 19.062 ↑ 2.1 324 1

Nested Loop (cost=1.54..60,211.54 rows=680 width=32) (actual time=0.418..19.062 rows=324 loops=1)

7. 0.062 0.477 ↑ 1.0 54 1

Nested Loop Left Join (cost=0.98..703.79 rows=54 width=26) (actual time=0.016..0.477 rows=54 loops=1)

8. 0.081 0.307 ↑ 1.0 54 1

Nested Loop (cost=0.70..685.62 rows=54 width=20) (actual time=0.011..0.307 rows=54 loops=1)

9. 0.118 0.118 ↑ 1.0 54 1

Index Scan using plates_pkey on plates ipl (cost=0.42..296.74 rows=54 width=14) (actual time=0.005..0.118 rows=54 loops=1)

  • Index Cond: (id = ANY ('{131849,131837,131827,131852,131817,131858,131838,131833,131834,131842,131867,131859,131818,131828,131855,131853,131832,131868,131850,131860,131829,131869,131857,131824,131845,131825,131854,131861,131835,131823,131836,131819,131843,131820,131848,131862,131816,131864,131865,131826,131863,131841,131821,131844,131856,131839,131846,131822,131830,131840,131847,131831,131851,131866}'::integer[]))
10. 0.108 0.108 ↑ 1.0 1 54

Index Scan using experiments_pkey on experiments ie (cost=0.29..7.19 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=54)

  • Index Cond: (id = ipl.experiment_id)
11. 0.108 0.108 ↑ 1.0 1 54

Index Scan using printing_prescriptions_experiment_id_key on printing_prescriptions ipp (cost=0.28..0.33 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=54)

  • Index Cond: (experiment_id = ie.id)
12. 18.360 18.360 ↑ 8.8 6 54

Index Scan using printings_plate_id_idx on printings ip (cost=0.56..1,101.47 rows=53 width=14) (actual time=0.334..0.340 rows=6 loops=54)

  • Index Cond: (plate_id = ipl.id)
  • Filter: (printed_at IS NULL)
13. 6.156 6.156 ↓ 2.9 40 324

Index Scan using ppc_unique_prescription_and_ordinal on printing_prescription_conditions ippc (cost=0.41..9.50 rows=14 width=15) (actual time=0.002..0.019 rows=40 loops=324)

  • Index Cond: (printing_prescription_id = ipp.id)
14. 8.100 8.100 ↑ 1.0 1 324

Index Scan using printings_pkey on printings p (cost=0.56..4.63 rows=1 width=10) (actual time=0.024..0.025 rows=1 loops=324)

  • Index Cond: (id = ip.id)
  • Filter: (printed_at IS NULL)
15. 227.124 227.124 ↑ 5.4 532 324

Index Scan using printing_reagents_printing_id_idx on transfer_perturbations tp (cost=0.56..63.45 rows=2,847 width=10) (actual time=0.008..0.701 rows=532 loops=324)

  • Index Cond: (printing_id = p.id)
Planning time : 1.278 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint plate_well_reagents_printing_reagent_id_fkey 1,206.718 ms 172260 0.007 ms
for constraint transfer_reagents_transfer_perturbation_id_fkey 1,315.120 ms 172260 0.008 ms
check_printing_reagents_mutability_trg 10,254.469 ms 172260 0.060 ms