explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xhse : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.095 ↓ 0.0 0 1

Limit (cost=8,501.65..8,501.72 rows=26 width=102) (actual time=0.095..0.095 rows=0 loops=1)

2. 0.030 0.093 ↓ 0.0 0 1

Sort (cost=8,501.65..8,505.05 rows=1,359 width=102) (actual time=0.093..0.093 rows=0 loops=1)

  • Sort Key: cwrtransactions_transaction.creation_time
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.063 ↓ 0.0 0 1

Nested Loop (cost=0.72..8,462.92 rows=1,359 width=102) (actual time=0.063..0.063 rows=0 loops=1)

4. 0.001 0.062 ↓ 0.0 0 1

Nested Loop (cost=0.29..11.53 rows=1 width=4) (actual time=0.062..0.062 rows=0 loops=1)

5. 0.061 0.061 ↓ 0.0 0 1

Index Scan using cwrfiles_ackfile_society_id_ed2ed169 on cwrfiles_ackfile (cost=0.29..8.30 rows=1 width=8) (actual time=0.061..0.061 rows=0 loops=1)

  • Index Cond: (society_id = 1)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on societies_society (cost=0.00..3.21 rows=1 width=4) (never executed)

  • Filter: (id = 1)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using cwrtransactions_transaction_ack_file_id_d5153401 on cwrtransactions_transaction (cost=0.44..8,428.95 rows=2,244 width=102) (never executed)

  • Index Cond: (ack_file_id = cwrfiles_ackfile.id)
Planning time : 51.142 ms