explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dLxf

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 61.117 ↑ 1.0 25 1

Limit (cost=3.56..1,987.02 rows=25 width=1,473) (actual time=6.157..61.117 rows=25 loops=1)

2. 0.062 61.101 ↑ 143,231.6 25 1

Nested Loop Left Join (cost=3.56..284,094,220.79 rows=3,580,790 width=1,473) (actual time=6.155..61.101 rows=25 loops=1)

3. 0.056 61.039 ↑ 143,231.6 25 1

Nested Loop Left Join (cost=3.27..263,710,672.94 rows=3,580,790 width=1,205) (actual time=6.144..61.039 rows=25 loops=1)

4. 0.081 60.958 ↑ 143,231.6 25 1

Nested Loop Left Join (cost=2.85..242,830,913.55 rows=3,580,790 width=1,201) (actual time=6.133..60.958 rows=25 loops=1)

5. 0.059 41.777 ↑ 143,231.6 25 1

Nested Loop Left Join (cost=2.42..221,736,589.60 rows=3,580,790 width=869) (actual time=5.572..41.777 rows=25 loops=1)

6. 0.045 20.243 ↑ 143,231.6 25 1

Nested Loop Left Join (cost=1.98..200,636,850.12 rows=3,580,790 width=865) (actual time=4.748..20.243 rows=25 loops=1)

7. 0.041 20.198 ↑ 143,231.6 25 1

Nested Loop Left Join (cost=1.69..180,253,302.27 rows=3,580,790 width=597) (actual time=4.740..20.198 rows=25 loops=1)

8. 0.062 20.157 ↑ 143,231.6 25 1

Nested Loop (cost=1.27..159,373,532.06 rows=3,580,790 width=593) (actual time=4.734..20.157 rows=25 loops=1)

9. 0.061 20.045 ↑ 143,231.6 25 1

Nested Loop (cost=0.98..138,989,984.21 rows=3,580,790 width=325) (actual time=4.723..20.045 rows=25 loops=1)

10. 19.884 19.884 ↑ 143,231.6 25 1

Index Scan using ix_receipts_contribution_amount on receipts (cost=0.56..118,110,295.16 rows=3,580,790 width=321) (actual time=4.703..19.884 rows=25 loops=1)

  • Filter: (recipient_committee_id = ANY ('{85496,85495,85494}'::integer[]))
  • Rows Removed by Filter: 7251
11. 0.100 0.100 ↑ 1.0 1 25

Index Scan using committees_pkey on committees committees_1 (cost=0.42..5.83 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=25)

  • Index Cond: (id = receipts.recipient_committee_id)
12. 0.050 0.050 ↑ 1.0 1 25

Index Scan using super_committees_pkey on super_committees super_committees_1 (cost=0.29..5.69 rows=1 width=272) (actual time=0.002..0.002 rows=1 loops=25)

  • Index Cond: (id = committees_1.super_committee_id)
13. 0.000 0.000 ↓ 0.0 0 25

Index Scan using committees_pkey on committees committees_2 (cost=0.42..5.83 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=25)

  • Index Cond: (receipts.donor_committee_id = id)
14. 0.000 0.000 ↓ 0.0 0 25

Index Scan using super_committees_pkey on super_committees super_committees_3 (cost=0.29..5.69 rows=1 width=272) (actual time=0.000..0.000 rows=0 loops=25)

  • Index Cond: (committees_2.super_committee_id = id)
15. 21.475 21.475 ↑ 1.0 1 25

Index Scan using ix_individual_matches_individual_id on individual_matches (cost=0.43..5.89 rows=1 width=8) (actual time=0.859..0.859 rows=1 loops=25)

  • Index Cond: (receipts.donor_individual_id = individual_id)
16. 19.100 19.100 ↑ 1.0 1 25

Index Scan using super_individuals_pkey on super_individuals (cost=0.43..5.89 rows=1 width=336) (actual time=0.764..0.764 rows=1 loops=25)

  • Index Cond: (individual_matches.super_individual_id = id)
17. 0.025 0.025 ↓ 0.0 0 25

Index Scan using committees_pkey on committees committees_3 (cost=0.42..5.83 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=25)

  • Index Cond: (receipts.conduit_committee_id = id)
18. 0.000 0.000 ↓ 0.0 0 25

Index Scan using super_committees_pkey on super_committees super_committees_2 (cost=0.29..5.69 rows=1 width=272) (actual time=0.000..0.000 rows=0 loops=25)

  • Index Cond: (committees_3.super_committee_id = id)
Planning time : 13.541 ms
Execution time : 61.276 ms