explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BsS4

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 2.151 ↑ 1.0 50 1

Limit (cost=0.71..1,286.28 rows=50 width=2,565) (actual time=0.065..2.151 rows=50 loops=1)

2. 0.066 2.142 ↑ 7,454.9 50 1

Nested Loop Left Join (cost=0.71..9,583,832.86 rows=372,747 width=2,565) (actual time=0.064..2.142 rows=50 loops=1)

  • Join Filter: (books_book.subscription_id = payments_subscriptiontype.id)
  • Rows Removed by Join Filter: 15
3. 0.074 2.076 ↑ 7,454.9 50 1

Nested Loop Left Join (cost=0.71..9,569,158.67 rows=372,747 width=2,539) (actual time=0.057..2.076 rows=50 loops=1)

4. 0.060 1.802 ↑ 7,454.9 50 1

Nested Loop Left Join (cost=0.29..6,474,695.32 rows=372,747 width=1,408) (actual time=0.047..1.802 rows=50 loops=1)

  • Filter: ((books_rightholder.litres_id <> ALL ('{9350031,9352293,9354901,9354639,9351777}'::text[])) OR (books_rightholder.litres_id IS NULL))
  • Rows Removed by Filter: 7
5. 1.571 1.571 ↑ 11,806.1 57 1

Seq Scan on books_book (cost=0.00..966,702.19 rows=672,949 width=1,223) (actual time=0.036..1.571 rows=57 loops=1)

  • Filter: (is_readable AND active AND (file_count > 0))
  • Rows Removed by Filter: 1801
6. 0.171 0.171 ↑ 1.0 1 57

Index Scan using books_rightholder_pkey on books_rightholder (cost=0.29..8.17 rows=1 width=185) (actual time=0.003..0.003 rows=1 loops=57)

  • Index Cond: (books_book.rightholder_id = id)
7. 0.200 0.200 ↑ 1.0 1 50

Index Scan using authors_author_pkey on authors_author (cost=0.42..8.30 rows=1 width=1,131) (actual time=0.004..0.004 rows=1 loops=50)

  • Index Cond: (books_book.main_author_id = id)
8. 0.000 0.000 ↑ 3.0 1 50

Materialize (cost=0.00..1.04 rows=3 width=26) (actual time=0.000..0.000 rows=1 loops=50)

9. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on payments_subscriptiontype (cost=0.00..1.03 rows=3 width=26) (actual time=0.003..0.004 rows=3 loops=1)