explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nINt

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 5,037.620 ↑ 19.1 10 1

Sort (cost=666,833.51..666,833.99 rows=191 width=1,315) (actual time=5,037.616..5,037.620 rows=10 loops=1)

  • Sort Key: qoa.created DESC
  • Sort Method: quicksort Memory: 34kB
2. 0.004 5,037.591 ↑ 19.1 10 1

Nested Loop (cost=1.30..666,826.27 rows=191 width=1,315) (actual time=5,020.734..5,037.591 rows=10 loops=1)

3. 0.032 5,037.547 ↑ 19.1 10 1

Nested Loop Left Join (cost=0.86..666,355.93 rows=191 width=1,315) (actual time=5,020.725..5,037.547 rows=10 loops=1)

  • Join Filter: (qds.object_id = qo.id)
  • Rows Removed by Join Filter: 190
4. 0.549 5,037.505 ↑ 19.1 10 1

Nested Loop Left Join (cost=0.86..666,297.26 rows=191 width=1,315) (actual time=5,020.709..5,037.505 rows=10 loops=1)

  • Join Filter: (qmb.object_id = qo.id)
  • Rows Removed by Join Filter: 6,320
5. 0.020 5,036.496 ↑ 19.1 10 1

Nested Loop Left Join (cost=0.86..664,438.68 rows=191 width=1,311) (actual time=5,020.456..5,036.496 rows=10 loops=1)

  • Join Filter: (qc.object_id = qo.id)
  • Rows Removed by Join Filter: 100
6. 0.006 5,036.456 ↑ 19.1 10 1

Nested Loop Left Join (cost=0.86..664,408.91 rows=191 width=1,307) (actual time=5,020.439..5,036.456 rows=10 loops=1)

7. 0.007 5,036.430 ↑ 19.1 10 1

Nested Loop Left Join (cost=0.58..664,350.10 rows=191 width=1,303) (actual time=5,020.434..5,036.430 rows=10 loops=1)

8. 0.018 5,036.373 ↑ 19.1 10 1

Nested Loop (cost=0.29..664,272.82 rows=191 width=1,299) (actual time=5,020.424..5,036.373 rows=10 loops=1)

9. 5,036.315 5,036.315 ↑ 19.1 10 1

Seq Scan on qbank_object_audit qoa (cost=0.00..663,878.70 rows=191 width=1,263) (actual time=5,020.409..5,036.315 rows=10 loops=1)

  • Filter: ((object_id = ANY (('{71111}'::text[])::integer[])) OR (foreign_object_id && ('{71111}'::text[])::integer[]))
  • Rows Removed by Filter: 3,483,865
10. 0.040 0.040 ↑ 1.0 1 10

Index Scan using pk_qbank_object_id on qbank_object qo (cost=0.29..2.05 rows=1 width=36) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: (id = qoa.object_id)
11. 0.050 0.050 ↑ 1.0 1 10

Index Scan using fki_qbank_media_objectid on qbank_media qm (cost=0.29..0.39 rows=1 width=8) (actual time=0.003..0.005 rows=1 loops=10)

  • Index Cond: (object_id = qo.id)
  • Filter: (replacedby IS NULL)
  • Rows Removed by Filter: 2
12. 0.020 0.020 ↓ 0.0 0 10

Index Scan using fki_qbank_folder_objectid on qbank_folder qf (cost=0.28..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=10)

  • Index Cond: (object_id = qo.id)
13. 0.014 0.020 ↑ 1.0 10 10

Materialize (cost=0.00..1.15 rows=10 width=8) (actual time=0.001..0.002 rows=10 loops=10)

14. 0.006 0.006 ↑ 1.0 10 1

Seq Scan on qbank_category qc (cost=0.00..1.10 rows=10 width=8) (actual time=0.005..0.006 rows=10 loops=1)

15. 0.305 0.460 ↑ 1.0 632 10

Materialize (cost=0.00..49.48 rows=632 width=8) (actual time=0.001..0.046 rows=632 loops=10)

16. 0.155 0.155 ↑ 1.0 632 1

Seq Scan on qbank_moodboard qmb (cost=0.00..46.32 rows=632 width=8) (actual time=0.005..0.155 rows=632 loops=1)

17. 0.002 0.010 ↑ 1.0 19 10

Materialize (cost=0.00..4.29 rows=19 width=8) (actual time=0.000..0.001 rows=19 loops=10)

18. 0.008 0.008 ↑ 1.0 19 1

Seq Scan on qbank_deployment_site qds (cost=0.00..4.19 rows=19 width=8) (actual time=0.003..0.008 rows=19 loops=1)

19. 0.040 0.040 ↑ 1.0 1 10

Index Scan using pk_statistics_session_id on account_session session (cost=0.43..2.45 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=10)

  • Index Cond: (id = qoa.session_id)
Planning time : 3.131 ms
Execution time : 5,037.767 ms